Tabela OMCDICTIONARYVAMB

Definicja tabeli OMCDICTIONARYVAMB

Name

OMCDICTIONARYVAMB

Code

OMCDICTIONARYVAMB

Comment

Slownik nazw uslug medycznych


Lista kolumn tabeli OMCDICTIONARYVAMB

Name

Code

OMCDICTIONARYVAMBID

OMCDICTIONARYVAMBID

ACTIVE

ACTIVE

PRICECODE

PRICECODE

TEXTCODE

TEXTCODE

SKIND

SKIND

AGE

AGE

IDPR

IDPR

WORK_DOCT

WORK_DOCT

WORK_SPEC

WORK_SPEC

STARTDT

STARTDT

STOPDT

STOPDT

INSERTINGPERSON

INSERTINGPERSON

INSERTDATE

INSERTDATE

LASTMODIFIEDPERSON

LASTMODIFIEDPERSON

LASTMODIFIEDDT

LASTMODIFIEDDT


Kolumna OMCDICTIONARYVAMBID tabeli OMCDICTIONARYVAMB

Definicja kolumny OMCDICTIONARYVAMBID tabeli OMCDICTIONARYVAMB

Name

OMCDICTIONARYVAMBID

Code

OMCDICTIONARYVAMBID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Id


Kolumna ACTIVE tabeli OMCDICTIONARYVAMB

Definicja kolumny ACTIVE tabeli OMCDICTIONARYVAMB

Name

ACTIVE

Code

ACTIVE

Data Type

NUMBER(1)

Mandatory

Yes

Comment

Aktywnosc rekordu


Kolumna PRICECODE tabeli OMCDICTIONARYVAMB

Definicja kolumny PRICECODE tabeli OMCDICTIONARYVAMB

Name

PRICECODE

Code

PRICECODE

Data Type

VARCHAR2(16)

Mandatory

Yes

Comment

Kod taryfy w cenniku


Kolumna TEXTCODE tabeli OMCDICTIONARYVAMB

Definicja kolumny TEXTCODE tabeli OMCDICTIONARYVAMB

Name

TEXTCODE

Code

TEXTCODE

Data Type

VARCHAR2(16)

Mandatory

Yes

Comment

Tekstowy kod taryfy


Kolumna SKIND tabeli OMCDICTIONARYVAMB

Definicja kolumny SKIND tabeli OMCDICTIONARYVAMB

Name

SKIND

Code

SKIND

Data Type

NUMBER(10)

Mandatory

No

Comment

Kod typu pomocy medycznej


Kolumna AGE tabeli OMCDICTIONARYVAMB

Definicja kolumny AGE tabeli OMCDICTIONARYVAMB

Name

AGE

Code

AGE

Data Type

NUMBER(10)

Mandatory

No

Comment

Grupa wiekowa obslugiwanych osób


Kolumna IDPR tabeli OMCDICTIONARYVAMB

Definicja kolumny IDPR tabeli OMCDICTIONARYVAMB

Name

IDPR

Code

IDPR

Data Type

VARCHAR2(16)

Mandatory

No

Comment

Kod profilu


Kolumna WORK_DOCT tabeli OMCDICTIONARYVAMB

Definicja kolumny WORK_DOCT tabeli OMCDICTIONARYVAMB

Name

WORK_DOCT

Code

WORK_DOCT

Data Type

VARCHAR2(16)

Mandatory

No

Comment

Pracochlonnosc lekarza


Kolumna WORK_SPEC tabeli OMCDICTIONARYVAMB

Definicja kolumny WORK_SPEC tabeli OMCDICTIONARYVAMB

Name

WORK_SPEC

Code

WORK_SPEC

Data Type

VARCHAR2(16)

Mandatory

No

Comment

Pracochlonnosc sredniego
personelu


Kolumna STARTDT tabeli OMCDICTIONARYVAMB

Definicja kolumny STARTDT tabeli OMCDICTIONARYVAMB

Name

STARTDT

Code

STARTDT

Data Type

DATE

Mandatory

No

Comment

Okres obowiazywania od


Kolumna STOPDT tabeli OMCDICTIONARYVAMB

Definicja kolumny STOPDT tabeli OMCDICTIONARYVAMB

Name

STOPDT

Code

STOPDT

Data Type

DATE

Mandatory

No

Comment

Okres obowiazywania do


Kolumna INSERTINGPERSON tabeli OMCDICTIONARYVAMB

Definicja kolumny INSERTINGPERSON tabeli OMCDICTIONARYVAMB

Name

INSERTINGPERSON

Code

INSERTINGPERSON

Data Type

NUMBER(10)

Mandatory

No

Comment

Osoba, która utworzyla
rekord


Kolumna INSERTDATE tabeli OMCDICTIONARYVAMB

Definicja kolumny INSERTDATE tabeli OMCDICTIONARYVAMB

Name

INSERTDATE

Code

INSERTDATE

Data Type

DATE

Mandatory

No

Comment

Data utworzenia rekordu


Kolumna LASTMODIFIEDPERSON tabeli OMCDICTIONARYVAMB

Definicja kolumny LASTMODIFIEDPERSON tabeli OMCDICTIONARYVAMB

Name

LASTMODIFIEDPERSON

Code

LASTMODIFIEDPERSON

Data Type

NUMBER(10)

Mandatory

No

Comment

Osoba, która
zmodyfikowala rekord


Kolumna LASTMODIFIEDDT tabeli OMCDICTIONARYVAMB

Definicja kolumny LASTMODIFIEDDT tabeli OMCDICTIONARYVAMB

Name

LASTMODIFIEDDT

Code

LASTMODIFIEDDT

Data Type

DATE

Mandatory

No

Comment

Data modyfikacji
rekordu


Lista kluczy tabeli OMCDICTIONARYVAMB

Name

Code

Primary

PKOMCDICTIONARYVAMBID

PKOMCDICTIONARYVAMBID

X


Klucz PKOMCDICTIONARYVAMBID tabeli OMCDICTIONARYVAMB

Definicja klucza PKOMCDICTIONARYVAMBID tabeli OMCDICTIONARYVAMB

Name

PKOMCDICTIONARYVAMBID

Code

PKOMCDICTIONARYVAMBID

Primary

Yes

Comment